﻿USE [RestaurantManagement]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Nguyễn Đức Thắng>
-- Create date: <15/03/2013>
-- =============================================
CREATE PROCEDURE [dbo].[Update_RestaurantArea]
			@RestaurantAreaID as uniqueidentifier,
			@RestaurantAreaCode as varchar(20),
			@RestaurantAreaName as nvarchar(50),
			@Description as nvarchar(255),
			@RestaurantID as uniqueidentifier,
			@IsActive as bit
 as 
		UPDATE dbo.[RestaurantArea] set 
			RestaurantAreaID= @RestaurantAreaID,
			RestaurantAreaCode= @RestaurantAreaCode,
			RestaurantAreaName= @RestaurantAreaName,
			Description= @Description,
			RestaurantID= @RestaurantID,
			IsActive= @IsActive
		WHERE 	(@RestaurantAreaID=dbo.[RestaurantArea].RestaurantAreaID)

GO